package cn.stylefeng.guns.modular.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import cn.stylefeng.guns.modular.entity.IdjActivityApply;
import cn.stylefeng.guns.modular.entity.responseVo.ActivityCountVo;

/**
 * <p>
 * 活动报名 Mapper 接口
 * </p>
 *
 * @author TANGWJ
 * @since 2020-08-04
 */
public interface IdjActivityApplyMapper extends BaseMapper<IdjActivityApply> {
	
    Page<Map<String, Object>> getList(Page page, @Param("userName") String userName, @Param("division") String division, @Param("userType") Integer userType, @Param("beginTime") String beginTime, @Param("endTime") String endTime, @Param("status") Integer status, @Param("sex") Integer sex, @Param("orderBy") String orderBy, @Param("order") String order);

    IdjActivityApply selectByActivityId(@Param("activityId") Long activityId);
    
    int setStatus(IdjActivityApply apply);
    
    List<ActivityCountVo> selectDivisionCount();
    
    ActivityCountVo selectSumCount();

}
